[dbo].[BAECustomerGetDirectory]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAECustomerGetDirectory

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@name	varchar(30)	30
@company	varchar(30)	30

SQL Script

create procedure [dbo].[BAECustomerGetDirectory] @name varchar(30),
     @company varchar(30) as
SELECT n.ID
    FROM Name n
    WHERE UPPER(LAST_FIRST) like '%' + UPPER(@name) + '%'
    AND UPPER(n.COMPANY) like '%' + UPPER(@company) + '%'

GO

Uses

[dbo].[Name]
dbo